package com.example.qxfw.common.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.example.qxfw.common.entity.qx.SpecialSrvStation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/************************************
*
* @author : HuangDeYin Jolly
* @since : JDK 11
* @Date : 2023/7/6  星期四   22:38
* @description : 此类用来
***************************************/
@Mapper

public interface SpecialSrvStationMapperXml extends BaseMapper<SpecialSrvStation> {
    /**
     * insert record to table
     * @param record the record
     * @return insert count
     */
    int insert(SpecialSrvStation record);

    /**
     * insert record to table selective
     * @param record the record
     * @return insert count
     */
    int insertSelective(SpecialSrvStation record);

    List<SpecialSrvStation> query(@Param("specialSrvStation") SpecialSrvStation specialSrvStation);

    List<SpecialSrvStation> queryDistinct(@Param("column") String column, @Param("query") String query, @Param("city") String city, @Param("order") String order, @Param("limit") Integer limit);

    //此方法用来对指数预报进行初始化是加载
    List<SpecialSrvStation> ybCityList();

    //通过站点名称获得站点编号
    List<SpecialSrvStation> queryListByStationName(@Param("stationName") String stationName);

    List<SpecialSrvStation> queryListByStationIdAndCity(@Param("longitude") String longitude, @Param("city") String city, @Param("latitude") String latitude);

}